create or replace trigger userID_before_insert
  before insert
  on USER1 
  for each row
declare
  -- local variables here
begin
  select user_id.nextval into :new.id from dual;
end userID_before_insert;
/
